﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true"
    CodeFile="WorkTimeOutList.aspx.cs" Inherits="WorkTime_WorkTimeOutList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Titile" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" runat="Server">
    <infolight:webdatasource id="Master" runat="server" autoapply="True" webdatasetid="WMaster"
        datamember="View_WorkTime_Out" cachedataset="True">
    </infolight:webdatasource>
    <infolight:webclientquery id="WebClientQuery1" runat="server" datasourceid="Master"
        font-names="Simsun" font-size="Small" GapHorizontal="20">
        <columns>
                    <InfoLight:WebQueryColumns Caption="员工编码" Column="EmployeeId"
                        DefaultValue="" NewLine="False" NotNull="False" NotNullBackColor="White" Text=""
                        Width="120" ColumnType="ClientQueryRefValColumn" WebRefVal="QueryEmp" />
                    <InfoLight:WebQueryColumns Caption="日期" Column="CurrDate" DefaultValue="" NewLine="False"
                        NotNull="False" NotNullBackColor="White" Text="" Width="120" ColumnType="ClientQueryCalendarColumn" />
                    <InfoLight:WebQueryColumns Caption="工作流标志" Column="FlowFlag" DefaultValue="" NewLine="False"
                        NotNull="False" NotNullBackColor="White" Text="" Width="120" ColumnType="ClientQueryComboBoxColumn" WebRefVal="QueryFlowFlag" />
                </columns>
    </infolight:webclientquery>
    <infolight:webdatasource id="wdsWorkTime_YearHolidayEmployeeId" runat="server" selectalias="Usasdb"
        selectcommand="select &#13;&#10;Employees.EmployeeID,&#13;&#10;Employees.EmpName,&#13;&#10;Department.DepartmentName &#13;&#10;FROM Employees&#13;&#10; left join Department on Employees.DepartmentId=Department.DepartmentId"
        cachedataset="True">
    </infolight:webdatasource>
    <infolight:webdatasource id="wsFlowFlag" runat="server" selectalias="Usasdb" selectcommand="select Sys_FlowFlag.FlowFlag,Sys_FlowFlag.FlowFlagName from Sys_FlowFlag">
    </infolight:webdatasource>
    <infolight:webrefval id="QueryFlowFlag" runat="server" datasourceid="wsFlowFlag"
        datatextfield="FlowFlagName" datavaluefield="FlowFlag" visible="False" width="136px">
        <columns>
                    <InfoLight:WebRefColumn ColumnName="FlowFlag" HeadText="FlowFlag" Width="100" />
                    <InfoLight:WebRefColumn ColumnName="FlowFlagName" HeadText="FlowFlagName" Width="100" />
                </columns>
    </infolight:webrefval>
    <infolight:webrefval id="QueryEmp" runat="server" allowadddata="False" bindingtext=""
        bindingvalue='<%# Bind("EmployeeId") %>' buttonimageurl="../Image/refval/RefVal.gif"
        databindingfield="" datasourceid="wdsWorkTime_YearHolidayEmployeeId" datatextfield="EmpName"
        datavaluefield="EmployeeID" multilanguage="False" postbackbutonclick="False"
        readonly="False" resxdataset="" resxfilepath="" updatepanelid="" usebuttonimage="True"
        visible="False" width="130px">
        <columns>
                    <InfoLight:WebRefColumn ColumnName="EmployeeID" HeadText="员工编号" Width="100" />
                    <InfoLight:WebRefColumn ColumnName="EmpName" HeadText="员工姓名" Width="100" />
                    <InfoLight:WebRefColumn ColumnName="DepartmentName" HeadText="所在部门" Width="100" />
                </columns>
    </infolight:webrefval>
    <infolight:webnavigator id="WebNavigator1" runat="server" backcolor="PowderBlue"
        bindingobject="wgvMaster" bordercolor="Silver" borderstyle="Groove" borderwidth="2px"
        height="22px" oncommand="WebNavigator1_Command" showdatastyle="GridStyle" statusstrip="WebStatusStrip1"
        visible="False" width="100%">
        <navcontrols>
                    <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                        ImageUrl="../image/uipics/query.gif" MouseOverImageUrl="../image/uipics/query2.gif"
                        Size="25" />
                    <InfoLight:ControlItem ControlName="Print" ControlText="ゴ" ControlType="Image" ControlVisible="False"
                        ImageUrl="../image/uipics/print.gif" MouseOverImageUrl="../image/uipics/print2.gif"
                        Size="25" />
                    <InfoLight:ControlItem ControlName="ClientQuery" ControlText="查询2" ControlType="Image"
                        ControlVisible="True" ImageUrl="../image/uipics/query.gif" MouseOverImageUrl="../image/uipics/query2.gif"
                        Size="25" />
                </navcontrols>
        <navstates>
                    <InfoLight:WebNavigatorStateItem StateText="Initial" />
                    <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                    <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                    <InfoLight:WebNavigatorStateItem StateText="Editing" />
                    <InfoLight:WebNavigatorStateItem StateText="Applying" />
                    <InfoLight:WebNavigatorStateItem StateText="Changing" />
                    <InfoLight:WebNavigatorStateItem StateText="Querying" />
                    <InfoLight:WebNavigatorStateItem StateText="Printing" />
                </navstates>
        <queryfields>
                    <InfoLight:WebQueryField Caption="员工编号" Condition="=" DefaultValue="" FieldName="EmployeeId"
                        Mode="RefVal" RefVal="QueryEmp" />
                    <InfoLight:WebQueryField Caption="请假类型编号" Condition="=" DefaultValue="" FieldName="LeaveTypeId"
                        Mode="ComboBox" RefVal="QueryLeaveType" />
                    <InfoLight:WebQueryField Caption="工作流标志" Condition="=" DefaultValue="" FieldName="FlowFlag"
                        Mode="RefVal" RefVal="QueryFlowFlag" />
                </queryfields>
    </infolight:webnavigator>
    <table cellpadding="0" cellspacing="5" class="TbSearch">
        <tr>
            <td style="width: 65%">
                <asp:Panel ID="Panel1" runat="server" Font-Size="Small" Height="100%" Width="100%">
                </asp:Panel>
            </td>
            <td align="center" style="width: 15%; height: 16px">
                <span class="roundbtn">
                    <asp:LinkButton ID="btnSearch" runat="server" Text="&nbsp;&nbsp;&nbsp;&nbsp;查 询&nbsp;&nbsp;&nbsp;&nbsp;" OnClick="btnSearch_Click"></asp:LinkButton>
                </span>
            </td>
            <td align="center" style="width: 15%; height: 16px">
                <span class="roundbtn">
                    <asp:LinkButton ID="btnClear" runat="server" Text="&nbsp;&nbsp;&nbsp;&nbsp;清 除&nbsp;&nbsp;&nbsp;&nbsp;" OnClick="btnClear_Click"></asp:LinkButton>
                </span>
            </td>
        </tr>
    </table>
    <infolight:webgridview id="wgvMaster" runat="server" cellpadding="5" datasourceid="Master"
        forecolor="#333333" width="100%" aborticonurl="../Image/UIPics/Abort.gif" addiconurl="../Image/UIPics/Add.gif"
        applyiconurl="../Image/UIPics/Apply.gif" canceliconurl="../Image/UIPics/Cancel.gif"
        mouseoveraborticonurl="../Image/UIPics/Abort2.gif" mouseoveraddiconurl="../Image/UIPics/Add2.gif"
        mouseoverapplyiconurl="../Image/UIPics/Apply2.gif" mouseovercanceliconurl="../Image/UIPics/Cancel2.gif"
        mouseoverokiconurl="../Image/UIPics/OK2.gif" mouseoverqueryiconurl="../Image/UIPics/Query2.gif"
        okiconurl="../Image/UIPics/OK.gif" 
        queryiconurl="../Image/UIPics/Query.gif" headerstylewrap="False"
        backcolor="White" bordercolor="White" borderstyle="Groove" borderwidth="2px"
        createinnernavigator="False" PageSize="15">
        <pagersettings mode="NumericFirstLast" />
        <footerstyle backcolor="#507CD1" forecolor="White" font-bold="True"></footerstyle>
        <navcontrols>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif"
                    ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif">
                </InfoLight:ControlItem>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif"
                    ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif">
                </InfoLight:ControlItem>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif"
                    ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif">
                </InfoLight:ControlItem>
            </navcontrols>
        <rowstyle backcolor="#EFF3FB"></rowstyle>
        <editrowstyle backcolor="#2461BF"></editrowstyle>
        <selectedrowstyle backcolor="#D1DDF1" forecolor="#333333" font-bold="True"></selectedrowstyle>
        <pagerstyle backcolor="LightBlue" forecolor="White" horizontalalign="Center"></pagerstyle>
        <headerstyle backcolor="DeepSkyBlue" forecolor="White" font-bold="True"></headerstyle>
        <alternatingrowstyle backcolor="White" bordercolor="White"></alternatingrowstyle>
        <columns>
                <asp:BoundField DataField="OutId" HeaderText="公出编号" SortExpression="OutId" />
                <asp:BoundField DataField="EmployeeId" HeaderText="员工编号" SortExpression="EmployeeId" />
                <asp:BoundField DataField="EmpName" HeaderText="员工姓名" SortExpression="EmpName" />
                <asp:BoundField DataField="DepartmentName" HeaderText="部门名称" SortExpression="DepartmentName" />
                <asp:BoundField DataField="CurrDate" HeaderText="日期" SortExpression="CurrDate" DataFormatString="{0:d}" HtmlEncode="False" />
                <asp:BoundField DataField="Destination" HeaderText="目的地" SortExpression="Destination" />
                <asp:TemplateField HeaderText="外出时间">
                    <itemtemplate>
<asp:Label id="Label1" runat="server" Text='<%# Eval("OutHour")+":"+Eval("OutSecond") %>' __designer:wfdid="w1"></asp:Label>
</itemtemplate>
                </asp:TemplateField>                
                <asp:TemplateField HeaderText="返回时间">                    
                    <itemtemplate>
<asp:Label runat="server" Text='<%# Eval("BackHour")+":"+Eval("BackSecond") %>' id="Label3"></asp:Label>
</itemtemplate>
                </asp:TemplateField>                
                <asp:BoundField DataField="Remark" HeaderText="备注" SortExpression="Remark" />
                <asp:BoundField DataField="FlowFlagName" HeaderText="流程标志" SortExpression="FlowFlagName" />
            </columns>
    </infolight:webgridview>
</asp:Content>
